package mn.idax.exchange.otc.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OTCOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OTCOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("Id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("Id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("Id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("Id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("Id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("Id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("Id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("Id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("Id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("Id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("Id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("Id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUniquekeyIsNull() {
            addCriterion("UniqueKey is null");
            return (Criteria) this;
        }

        public Criteria andUniquekeyIsNotNull() {
            addCriterion("UniqueKey is not null");
            return (Criteria) this;
        }

        public Criteria andUniquekeyEqualTo(String value) {
            addCriterion("UniqueKey =", value, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andUniquekeyNotEqualTo(String value) {
            addCriterion("UniqueKey <>", value, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andUniquekeyGreaterThan(String value) {
            addCriterion("UniqueKey >", value, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andUniquekeyGreaterThanOrEqualTo(String value) {
            addCriterion("UniqueKey >=", value, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andUniquekeyLessThan(String value) {
            addCriterion("UniqueKey <", value, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andUniquekeyLessThanOrEqualTo(String value) {
            addCriterion("UniqueKey <=", value, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andUniquekeyLike(String value) {
            addCriterion("UniqueKey like", value, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andUniquekeyNotLike(String value) {
            addCriterion("UniqueKey not like", value, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andUniquekeyIn(List<String> values) {
            addCriterion("UniqueKey in", values, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andUniquekeyNotIn(List<String> values) {
            addCriterion("UniqueKey not in", values, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andUniquekeyBetween(String value1, String value2) {
            addCriterion("UniqueKey between", value1, value2, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andUniquekeyNotBetween(String value1, String value2) {
            addCriterion("UniqueKey not between", value1, value2, "uniquekey");
            return (Criteria) this;
        }

        public Criteria andNumberIsNull() {
            addCriterion("Number is null");
            return (Criteria) this;
        }

        public Criteria andNumberIsNotNull() {
            addCriterion("Number is not null");
            return (Criteria) this;
        }

        public Criteria andNumberEqualTo(String value) {
            addCriterion("Number =", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotEqualTo(String value) {
            addCriterion("Number <>", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberGreaterThan(String value) {
            addCriterion("Number >", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberGreaterThanOrEqualTo(String value) {
            addCriterion("Number >=", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberLessThan(String value) {
            addCriterion("Number <", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberLessThanOrEqualTo(String value) {
            addCriterion("Number <=", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberLike(String value) {
            addCriterion("Number like", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotLike(String value) {
            addCriterion("Number not like", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberIn(List<String> values) {
            addCriterion("Number in", values, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotIn(List<String> values) {
            addCriterion("Number not in", values, "number");
            return (Criteria) this;
        }

        public Criteria andNumberBetween(String value1, String value2) {
            addCriterion("Number between", value1, value2, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotBetween(String value1, String value2) {
            addCriterion("Number not between", value1, value2, "number");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("Type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("Type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("Type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("Type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("Type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("Type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("Type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("Type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("Type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("Type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("Type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("Type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andAdidIsNull() {
            addCriterion("AdId is null");
            return (Criteria) this;
        }

        public Criteria andAdidIsNotNull() {
            addCriterion("AdId is not null");
            return (Criteria) this;
        }

        public Criteria andAdidEqualTo(Integer value) {
            addCriterion("AdId =", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidNotEqualTo(Integer value) {
            addCriterion("AdId <>", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidGreaterThan(Integer value) {
            addCriterion("AdId >", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidGreaterThanOrEqualTo(Integer value) {
            addCriterion("AdId >=", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidLessThan(Integer value) {
            addCriterion("AdId <", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidLessThanOrEqualTo(Integer value) {
            addCriterion("AdId <=", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidIn(List<Integer> values) {
            addCriterion("AdId in", values, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidNotIn(List<Integer> values) {
            addCriterion("AdId not in", values, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidBetween(Integer value1, Integer value2) {
            addCriterion("AdId between", value1, value2, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidNotBetween(Integer value1, Integer value2) {
            addCriterion("AdId not between", value1, value2, "adid");
            return (Criteria) this;
        }

        public Criteria andBuyerIsNull() {
            addCriterion("Buyer is null");
            return (Criteria) this;
        }

        public Criteria andBuyerIsNotNull() {
            addCriterion("Buyer is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerEqualTo(Integer value) {
            addCriterion("Buyer =", value, "buyer");
            return (Criteria) this;
        }

        public Criteria andBuyerNotEqualTo(Integer value) {
            addCriterion("Buyer <>", value, "buyer");
            return (Criteria) this;
        }

        public Criteria andBuyerGreaterThan(Integer value) {
            addCriterion("Buyer >", value, "buyer");
            return (Criteria) this;
        }

        public Criteria andBuyerGreaterThanOrEqualTo(Integer value) {
            addCriterion("Buyer >=", value, "buyer");
            return (Criteria) this;
        }

        public Criteria andBuyerLessThan(Integer value) {
            addCriterion("Buyer <", value, "buyer");
            return (Criteria) this;
        }

        public Criteria andBuyerLessThanOrEqualTo(Integer value) {
            addCriterion("Buyer <=", value, "buyer");
            return (Criteria) this;
        }

        public Criteria andBuyerIn(List<Integer> values) {
            addCriterion("Buyer in", values, "buyer");
            return (Criteria) this;
        }

        public Criteria andBuyerNotIn(List<Integer> values) {
            addCriterion("Buyer not in", values, "buyer");
            return (Criteria) this;
        }

        public Criteria andBuyerBetween(Integer value1, Integer value2) {
            addCriterion("Buyer between", value1, value2, "buyer");
            return (Criteria) this;
        }

        public Criteria andBuyerNotBetween(Integer value1, Integer value2) {
            addCriterion("Buyer not between", value1, value2, "buyer");
            return (Criteria) this;
        }

        public Criteria andSellerIsNull() {
            addCriterion("Seller is null");
            return (Criteria) this;
        }

        public Criteria andSellerIsNotNull() {
            addCriterion("Seller is not null");
            return (Criteria) this;
        }

        public Criteria andSellerEqualTo(Integer value) {
            addCriterion("Seller =", value, "seller");
            return (Criteria) this;
        }

        public Criteria andSellerNotEqualTo(Integer value) {
            addCriterion("Seller <>", value, "seller");
            return (Criteria) this;
        }

        public Criteria andSellerGreaterThan(Integer value) {
            addCriterion("Seller >", value, "seller");
            return (Criteria) this;
        }

        public Criteria andSellerGreaterThanOrEqualTo(Integer value) {
            addCriterion("Seller >=", value, "seller");
            return (Criteria) this;
        }

        public Criteria andSellerLessThan(Integer value) {
            addCriterion("Seller <", value, "seller");
            return (Criteria) this;
        }

        public Criteria andSellerLessThanOrEqualTo(Integer value) {
            addCriterion("Seller <=", value, "seller");
            return (Criteria) this;
        }

        public Criteria andSellerIn(List<Integer> values) {
            addCriterion("Seller in", values, "seller");
            return (Criteria) this;
        }

        public Criteria andSellerNotIn(List<Integer> values) {
            addCriterion("Seller not in", values, "seller");
            return (Criteria) this;
        }

        public Criteria andSellerBetween(Integer value1, Integer value2) {
            addCriterion("Seller between", value1, value2, "seller");
            return (Criteria) this;
        }

        public Criteria andSellerNotBetween(Integer value1, Integer value2) {
            addCriterion("Seller not between", value1, value2, "seller");
            return (Criteria) this;
        }

        public Criteria andSelltypeIsNull() {
            addCriterion("SellType is null");
            return (Criteria) this;
        }

        public Criteria andSelltypeIsNotNull() {
            addCriterion("SellType is not null");
            return (Criteria) this;
        }

        public Criteria andSelltypeEqualTo(Integer value) {
            addCriterion("SellType =", value, "selltype");
            return (Criteria) this;
        }

        public Criteria andSelltypeNotEqualTo(Integer value) {
            addCriterion("SellType <>", value, "selltype");
            return (Criteria) this;
        }

        public Criteria andSelltypeGreaterThan(Integer value) {
            addCriterion("SellType >", value, "selltype");
            return (Criteria) this;
        }

        public Criteria andSelltypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("SellType >=", value, "selltype");
            return (Criteria) this;
        }

        public Criteria andSelltypeLessThan(Integer value) {
            addCriterion("SellType <", value, "selltype");
            return (Criteria) this;
        }

        public Criteria andSelltypeLessThanOrEqualTo(Integer value) {
            addCriterion("SellType <=", value, "selltype");
            return (Criteria) this;
        }

        public Criteria andSelltypeIn(List<Integer> values) {
            addCriterion("SellType in", values, "selltype");
            return (Criteria) this;
        }

        public Criteria andSelltypeNotIn(List<Integer> values) {
            addCriterion("SellType not in", values, "selltype");
            return (Criteria) this;
        }

        public Criteria andSelltypeBetween(Integer value1, Integer value2) {
            addCriterion("SellType between", value1, value2, "selltype");
            return (Criteria) this;
        }

        public Criteria andSelltypeNotBetween(Integer value1, Integer value2) {
            addCriterion("SellType not between", value1, value2, "selltype");
            return (Criteria) this;
        }

        public Criteria andSellaccountIsNull() {
            addCriterion("SellAccount is null");
            return (Criteria) this;
        }

        public Criteria andSellaccountIsNotNull() {
            addCriterion("SellAccount is not null");
            return (Criteria) this;
        }

        public Criteria andSellaccountEqualTo(String value) {
            addCriterion("SellAccount =", value, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andSellaccountNotEqualTo(String value) {
            addCriterion("SellAccount <>", value, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andSellaccountGreaterThan(String value) {
            addCriterion("SellAccount >", value, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andSellaccountGreaterThanOrEqualTo(String value) {
            addCriterion("SellAccount >=", value, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andSellaccountLessThan(String value) {
            addCriterion("SellAccount <", value, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andSellaccountLessThanOrEqualTo(String value) {
            addCriterion("SellAccount <=", value, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andSellaccountLike(String value) {
            addCriterion("SellAccount like", value, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andSellaccountNotLike(String value) {
            addCriterion("SellAccount not like", value, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andSellaccountIn(List<String> values) {
            addCriterion("SellAccount in", values, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andSellaccountNotIn(List<String> values) {
            addCriterion("SellAccount not in", values, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andSellaccountBetween(String value1, String value2) {
            addCriterion("SellAccount between", value1, value2, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andSellaccountNotBetween(String value1, String value2) {
            addCriterion("SellAccount not between", value1, value2, "sellaccount");
            return (Criteria) this;
        }

        public Criteria andPairnameIsNull() {
            addCriterion("PairName is null");
            return (Criteria) this;
        }

        public Criteria andPairnameIsNotNull() {
            addCriterion("PairName is not null");
            return (Criteria) this;
        }

        public Criteria andPairnameEqualTo(String value) {
            addCriterion("PairName =", value, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairnameNotEqualTo(String value) {
            addCriterion("PairName <>", value, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairnameGreaterThan(String value) {
            addCriterion("PairName >", value, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairnameGreaterThanOrEqualTo(String value) {
            addCriterion("PairName >=", value, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairnameLessThan(String value) {
            addCriterion("PairName <", value, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairnameLessThanOrEqualTo(String value) {
            addCriterion("PairName <=", value, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairnameLike(String value) {
            addCriterion("PairName like", value, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairnameNotLike(String value) {
            addCriterion("PairName not like", value, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairnameIn(List<String> values) {
            addCriterion("PairName in", values, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairnameNotIn(List<String> values) {
            addCriterion("PairName not in", values, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairnameBetween(String value1, String value2) {
            addCriterion("PairName between", value1, value2, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairnameNotBetween(String value1, String value2) {
            addCriterion("PairName not between", value1, value2, "pairname");
            return (Criteria) this;
        }

        public Criteria andPairpriceIsNull() {
            addCriterion("PairPrice is null");
            return (Criteria) this;
        }

        public Criteria andPairpriceIsNotNull() {
            addCriterion("PairPrice is not null");
            return (Criteria) this;
        }

        public Criteria andPairpriceEqualTo(BigDecimal value) {
            addCriterion("PairPrice =", value, "pairprice");
            return (Criteria) this;
        }

        public Criteria andPairpriceNotEqualTo(BigDecimal value) {
            addCriterion("PairPrice <>", value, "pairprice");
            return (Criteria) this;
        }

        public Criteria andPairpriceGreaterThan(BigDecimal value) {
            addCriterion("PairPrice >", value, "pairprice");
            return (Criteria) this;
        }

        public Criteria andPairpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PairPrice >=", value, "pairprice");
            return (Criteria) this;
        }

        public Criteria andPairpriceLessThan(BigDecimal value) {
            addCriterion("PairPrice <", value, "pairprice");
            return (Criteria) this;
        }

        public Criteria andPairpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PairPrice <=", value, "pairprice");
            return (Criteria) this;
        }

        public Criteria andPairpriceIn(List<BigDecimal> values) {
            addCriterion("PairPrice in", values, "pairprice");
            return (Criteria) this;
        }

        public Criteria andPairpriceNotIn(List<BigDecimal> values) {
            addCriterion("PairPrice not in", values, "pairprice");
            return (Criteria) this;
        }

        public Criteria andPairpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PairPrice between", value1, value2, "pairprice");
            return (Criteria) this;
        }

        public Criteria andPairpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PairPrice not between", value1, value2, "pairprice");
            return (Criteria) this;
        }

        public Criteria andQtyIsNull() {
            addCriterion("Qty is null");
            return (Criteria) this;
        }

        public Criteria andQtyIsNotNull() {
            addCriterion("Qty is not null");
            return (Criteria) this;
        }

        public Criteria andQtyEqualTo(BigDecimal value) {
            addCriterion("Qty =", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotEqualTo(BigDecimal value) {
            addCriterion("Qty <>", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThan(BigDecimal value) {
            addCriterion("Qty >", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty >=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThan(BigDecimal value) {
            addCriterion("Qty <", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty <=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyIn(List<BigDecimal> values) {
            addCriterion("Qty in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotIn(List<BigDecimal> values) {
            addCriterion("Qty not in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty not between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andMoneytypeIsNull() {
            addCriterion("MoneyType is null");
            return (Criteria) this;
        }

        public Criteria andMoneytypeIsNotNull() {
            addCriterion("MoneyType is not null");
            return (Criteria) this;
        }

        public Criteria andMoneytypeEqualTo(Integer value) {
            addCriterion("MoneyType =", value, "moneytype");
            return (Criteria) this;
        }

        public Criteria andMoneytypeNotEqualTo(Integer value) {
            addCriterion("MoneyType <>", value, "moneytype");
            return (Criteria) this;
        }

        public Criteria andMoneytypeGreaterThan(Integer value) {
            addCriterion("MoneyType >", value, "moneytype");
            return (Criteria) this;
        }

        public Criteria andMoneytypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("MoneyType >=", value, "moneytype");
            return (Criteria) this;
        }

        public Criteria andMoneytypeLessThan(Integer value) {
            addCriterion("MoneyType <", value, "moneytype");
            return (Criteria) this;
        }

        public Criteria andMoneytypeLessThanOrEqualTo(Integer value) {
            addCriterion("MoneyType <=", value, "moneytype");
            return (Criteria) this;
        }

        public Criteria andMoneytypeIn(List<Integer> values) {
            addCriterion("MoneyType in", values, "moneytype");
            return (Criteria) this;
        }

        public Criteria andMoneytypeNotIn(List<Integer> values) {
            addCriterion("MoneyType not in", values, "moneytype");
            return (Criteria) this;
        }

        public Criteria andMoneytypeBetween(Integer value1, Integer value2) {
            addCriterion("MoneyType between", value1, value2, "moneytype");
            return (Criteria) this;
        }

        public Criteria andMoneytypeNotBetween(Integer value1, Integer value2) {
            addCriterion("MoneyType not between", value1, value2, "moneytype");
            return (Criteria) this;
        }

        public Criteria andMoneyIsNull() {
            addCriterion("Money is null");
            return (Criteria) this;
        }

        public Criteria andMoneyIsNotNull() {
            addCriterion("Money is not null");
            return (Criteria) this;
        }

        public Criteria andMoneyEqualTo(BigDecimal value) {
            addCriterion("Money =", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotEqualTo(BigDecimal value) {
            addCriterion("Money <>", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyGreaterThan(BigDecimal value) {
            addCriterion("Money >", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Money >=", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyLessThan(BigDecimal value) {
            addCriterion("Money <", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Money <=", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyIn(List<BigDecimal> values) {
            addCriterion("Money in", values, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotIn(List<BigDecimal> values) {
            addCriterion("Money not in", values, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Money between", value1, value2, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Money not between", value1, value2, "money");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeIsNull() {
            addCriterion("BuyerProcedureFee is null");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeIsNotNull() {
            addCriterion("BuyerProcedureFee is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeEqualTo(BigDecimal value) {
            addCriterion("BuyerProcedureFee =", value, "buyerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeNotEqualTo(BigDecimal value) {
            addCriterion("BuyerProcedureFee <>", value, "buyerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeGreaterThan(BigDecimal value) {
            addCriterion("BuyerProcedureFee >", value, "buyerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BuyerProcedureFee >=", value, "buyerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeLessThan(BigDecimal value) {
            addCriterion("BuyerProcedureFee <", value, "buyerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BuyerProcedureFee <=", value, "buyerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeIn(List<BigDecimal> values) {
            addCriterion("BuyerProcedureFee in", values, "buyerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeNotIn(List<BigDecimal> values) {
            addCriterion("BuyerProcedureFee not in", values, "buyerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BuyerProcedureFee between", value1, value2, "buyerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BuyerProcedureFee not between", value1, value2, "buyerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateIsNull() {
            addCriterion("BuyerProcedureFeeRate is null");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateIsNotNull() {
            addCriterion("BuyerProcedureFeeRate is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateEqualTo(BigDecimal value) {
            addCriterion("BuyerProcedureFeeRate =", value, "buyerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateNotEqualTo(BigDecimal value) {
            addCriterion("BuyerProcedureFeeRate <>", value, "buyerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateGreaterThan(BigDecimal value) {
            addCriterion("BuyerProcedureFeeRate >", value, "buyerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BuyerProcedureFeeRate >=", value, "buyerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateLessThan(BigDecimal value) {
            addCriterion("BuyerProcedureFeeRate <", value, "buyerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BuyerProcedureFeeRate <=", value, "buyerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateIn(List<BigDecimal> values) {
            addCriterion("BuyerProcedureFeeRate in", values, "buyerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateNotIn(List<BigDecimal> values) {
            addCriterion("BuyerProcedureFeeRate not in", values, "buyerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BuyerProcedureFeeRate between", value1, value2, "buyerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andBuyerprocedurefeerateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BuyerProcedureFeeRate not between", value1, value2, "buyerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeIsNull() {
            addCriterion("SellerProcedureFee is null");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeIsNotNull() {
            addCriterion("SellerProcedureFee is not null");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeEqualTo(BigDecimal value) {
            addCriterion("SellerProcedureFee =", value, "sellerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeNotEqualTo(BigDecimal value) {
            addCriterion("SellerProcedureFee <>", value, "sellerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeGreaterThan(BigDecimal value) {
            addCriterion("SellerProcedureFee >", value, "sellerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SellerProcedureFee >=", value, "sellerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeLessThan(BigDecimal value) {
            addCriterion("SellerProcedureFee <", value, "sellerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SellerProcedureFee <=", value, "sellerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeIn(List<BigDecimal> values) {
            addCriterion("SellerProcedureFee in", values, "sellerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeNotIn(List<BigDecimal> values) {
            addCriterion("SellerProcedureFee not in", values, "sellerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SellerProcedureFee between", value1, value2, "sellerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SellerProcedureFee not between", value1, value2, "sellerprocedurefee");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateIsNull() {
            addCriterion("SellerProcedureFeeRate is null");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateIsNotNull() {
            addCriterion("SellerProcedureFeeRate is not null");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateEqualTo(BigDecimal value) {
            addCriterion("SellerProcedureFeeRate =", value, "sellerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateNotEqualTo(BigDecimal value) {
            addCriterion("SellerProcedureFeeRate <>", value, "sellerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateGreaterThan(BigDecimal value) {
            addCriterion("SellerProcedureFeeRate >", value, "sellerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SellerProcedureFeeRate >=", value, "sellerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateLessThan(BigDecimal value) {
            addCriterion("SellerProcedureFeeRate <", value, "sellerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SellerProcedureFeeRate <=", value, "sellerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateIn(List<BigDecimal> values) {
            addCriterion("SellerProcedureFeeRate in", values, "sellerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateNotIn(List<BigDecimal> values) {
            addCriterion("SellerProcedureFeeRate not in", values, "sellerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SellerProcedureFeeRate between", value1, value2, "sellerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andSellerprocedurefeerateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SellerProcedureFeeRate not between", value1, value2, "sellerprocedurefeerate");
            return (Criteria) this;
        }

        public Criteria andOrderstateIsNull() {
            addCriterion("OrderState is null");
            return (Criteria) this;
        }

        public Criteria andOrderstateIsNotNull() {
            addCriterion("OrderState is not null");
            return (Criteria) this;
        }

        public Criteria andOrderstateEqualTo(Integer value) {
            addCriterion("OrderState =", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateNotEqualTo(Integer value) {
            addCriterion("OrderState <>", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateGreaterThan(Integer value) {
            addCriterion("OrderState >", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateGreaterThanOrEqualTo(Integer value) {
            addCriterion("OrderState >=", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateLessThan(Integer value) {
            addCriterion("OrderState <", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateLessThanOrEqualTo(Integer value) {
            addCriterion("OrderState <=", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateIn(List<Integer> values) {
            addCriterion("OrderState in", values, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateNotIn(List<Integer> values) {
            addCriterion("OrderState not in", values, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateBetween(Integer value1, Integer value2) {
            addCriterion("OrderState between", value1, value2, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateNotBetween(Integer value1, Integer value2) {
            addCriterion("OrderState not between", value1, value2, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrdersourceIsNull() {
            addCriterion("OrderSource is null");
            return (Criteria) this;
        }

        public Criteria andOrdersourceIsNotNull() {
            addCriterion("OrderSource is not null");
            return (Criteria) this;
        }

        public Criteria andOrdersourceEqualTo(Integer value) {
            addCriterion("OrderSource =", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceNotEqualTo(Integer value) {
            addCriterion("OrderSource <>", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceGreaterThan(Integer value) {
            addCriterion("OrderSource >", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceGreaterThanOrEqualTo(Integer value) {
            addCriterion("OrderSource >=", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceLessThan(Integer value) {
            addCriterion("OrderSource <", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceLessThanOrEqualTo(Integer value) {
            addCriterion("OrderSource <=", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceIn(List<Integer> values) {
            addCriterion("OrderSource in", values, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceNotIn(List<Integer> values) {
            addCriterion("OrderSource not in", values, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceBetween(Integer value1, Integer value2) {
            addCriterion("OrderSource between", value1, value2, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceNotBetween(Integer value1, Integer value2) {
            addCriterion("OrderSource not between", value1, value2, "ordersource");
            return (Criteria) this;
        }

        public Criteria andCaneltimeIsNull() {
            addCriterion("CanelTime is null");
            return (Criteria) this;
        }

        public Criteria andCaneltimeIsNotNull() {
            addCriterion("CanelTime is not null");
            return (Criteria) this;
        }

        public Criteria andCaneltimeEqualTo(Date value) {
            addCriterion("CanelTime =", value, "caneltime");
            return (Criteria) this;
        }

        public Criteria andCaneltimeNotEqualTo(Date value) {
            addCriterion("CanelTime <>", value, "caneltime");
            return (Criteria) this;
        }

        public Criteria andCaneltimeGreaterThan(Date value) {
            addCriterion("CanelTime >", value, "caneltime");
            return (Criteria) this;
        }

        public Criteria andCaneltimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CanelTime >=", value, "caneltime");
            return (Criteria) this;
        }

        public Criteria andCaneltimeLessThan(Date value) {
            addCriterion("CanelTime <", value, "caneltime");
            return (Criteria) this;
        }

        public Criteria andCaneltimeLessThanOrEqualTo(Date value) {
            addCriterion("CanelTime <=", value, "caneltime");
            return (Criteria) this;
        }

        public Criteria andCaneltimeIn(List<Date> values) {
            addCriterion("CanelTime in", values, "caneltime");
            return (Criteria) this;
        }

        public Criteria andCaneltimeNotIn(List<Date> values) {
            addCriterion("CanelTime not in", values, "caneltime");
            return (Criteria) this;
        }

        public Criteria andCaneltimeBetween(Date value1, Date value2) {
            addCriterion("CanelTime between", value1, value2, "caneltime");
            return (Criteria) this;
        }

        public Criteria andCaneltimeNotBetween(Date value1, Date value2) {
            addCriterion("CanelTime not between", value1, value2, "caneltime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeIsNull() {
            addCriterion("ExpireTime is null");
            return (Criteria) this;
        }

        public Criteria andExpiretimeIsNotNull() {
            addCriterion("ExpireTime is not null");
            return (Criteria) this;
        }

        public Criteria andExpiretimeEqualTo(Date value) {
            addCriterion("ExpireTime =", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeNotEqualTo(Date value) {
            addCriterion("ExpireTime <>", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeGreaterThan(Date value) {
            addCriterion("ExpireTime >", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ExpireTime >=", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeLessThan(Date value) {
            addCriterion("ExpireTime <", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeLessThanOrEqualTo(Date value) {
            addCriterion("ExpireTime <=", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeIn(List<Date> values) {
            addCriterion("ExpireTime in", values, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeNotIn(List<Date> values) {
            addCriterion("ExpireTime not in", values, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeBetween(Date value1, Date value2) {
            addCriterion("ExpireTime between", value1, value2, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeNotBetween(Date value1, Date value2) {
            addCriterion("ExpireTime not between", value1, value2, "expiretime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("CreateTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("CreateTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("CreateTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CreateTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("CreateTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("CreateTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("CreateTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("CreateTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("CreateTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("CreateTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("UpdateTime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("UpdateTime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("UpdateTime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UpdateTime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("UpdateTime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("UpdateTime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("UpdateTime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("UpdateTime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("UpdateTime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("UpdateTime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateIsNull() {
            addCriterion("OrderSubState is null");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateIsNotNull() {
            addCriterion("OrderSubState is not null");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateEqualTo(Integer value) {
            addCriterion("OrderSubState =", value, "ordersubstate");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateNotEqualTo(Integer value) {
            addCriterion("OrderSubState <>", value, "ordersubstate");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateGreaterThan(Integer value) {
            addCriterion("OrderSubState >", value, "ordersubstate");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateGreaterThanOrEqualTo(Integer value) {
            addCriterion("OrderSubState >=", value, "ordersubstate");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateLessThan(Integer value) {
            addCriterion("OrderSubState <", value, "ordersubstate");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateLessThanOrEqualTo(Integer value) {
            addCriterion("OrderSubState <=", value, "ordersubstate");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateIn(List<Integer> values) {
            addCriterion("OrderSubState in", values, "ordersubstate");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateNotIn(List<Integer> values) {
            addCriterion("OrderSubState not in", values, "ordersubstate");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateBetween(Integer value1, Integer value2) {
            addCriterion("OrderSubState between", value1, value2, "ordersubstate");
            return (Criteria) this;
        }

        public Criteria andOrdersubstateNotBetween(Integer value1, Integer value2) {
            addCriterion("OrderSubState not between", value1, value2, "ordersubstate");
            return (Criteria) this;
        }

        public Criteria andCoinidIsNull() {
            addCriterion("CoinId is null");
            return (Criteria) this;
        }

        public Criteria andCoinidIsNotNull() {
            addCriterion("CoinId is not null");
            return (Criteria) this;
        }

        public Criteria andCoinidEqualTo(Integer value) {
            addCriterion("CoinId =", value, "coinid");
            return (Criteria) this;
        }

        public Criteria andCoinidNotEqualTo(Integer value) {
            addCriterion("CoinId <>", value, "coinid");
            return (Criteria) this;
        }

        public Criteria andCoinidGreaterThan(Integer value) {
            addCriterion("CoinId >", value, "coinid");
            return (Criteria) this;
        }

        public Criteria andCoinidGreaterThanOrEqualTo(Integer value) {
            addCriterion("CoinId >=", value, "coinid");
            return (Criteria) this;
        }

        public Criteria andCoinidLessThan(Integer value) {
            addCriterion("CoinId <", value, "coinid");
            return (Criteria) this;
        }

        public Criteria andCoinidLessThanOrEqualTo(Integer value) {
            addCriterion("CoinId <=", value, "coinid");
            return (Criteria) this;
        }

        public Criteria andCoinidIn(List<Integer> values) {
            addCriterion("CoinId in", values, "coinid");
            return (Criteria) this;
        }

        public Criteria andCoinidNotIn(List<Integer> values) {
            addCriterion("CoinId not in", values, "coinid");
            return (Criteria) this;
        }

        public Criteria andCoinidBetween(Integer value1, Integer value2) {
            addCriterion("CoinId between", value1, value2, "coinid");
            return (Criteria) this;
        }

        public Criteria andCoinidNotBetween(Integer value1, Integer value2) {
            addCriterion("CoinId not between", value1, value2, "coinid");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}